package com.jiang.demo2.map;


import com.jiang.demo2.table.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;

@Mapper
public interface UserInfoDao {
    @Select("SELECT * FROM userinfo WHERE usercode = #{usercode}")
    UserInfo getUserInfo(@Param("usercode") String usercode);
//
//    @Insert("INSERT INTO happiness(city, num) VALUES(#{city}, #{num})")
//    int insertHappiness(@Param("city") String city, @Param("num") Integer num);


}
